National_Pride_Large

Data/import.do:158

→ Data/EVC_da..Migration_Database.dta ↘

Data/EVC_data/OECD data/Migration/MIG_Data_International_Migration_Database.dta open
file:data:dta

⚠ All statistics are based on a random subsample of 142857 observations. You can change this by increasing statdoc.stata.maxvarobs in statdoc.properties or by setting a @statdoc.full flag for the dataset with notes _dta:@statdoc.full.

All properties
key	content
N	255341
_subsample	142857
datasignature	255341:7(64565):140901362:4211535421
date	Wed Sep 23 19:13:12 EST 2015
lastmodified	1442999592000
variables	7

Variable Graph Type N Descriptives Label

[+] country
@MIG_Data_Internationa..abase.dta

string
(str15)

142857
(34)

Country

All properties
key	content
N	142857
N_unique	34
class	string
example0	Spain
label	Country
type	str15

Data Manipulations with country
file	#	command

Script Output

@example0 Spain
@type str15
@label Country
@class string
@N_unique 34
@N 142857

[+] countryoforigin
@MIG_Data_Internationa..abase.dta

string
(str38)

142857
(216)

Country of origin

All properties
key	content
N	142857
N_unique	216
class	string
example0	Belarus
label	Country of origin
type	str38

Data Manipulations with countryoforigin
file	#	command

Script Output

@example0 Belarus
@type str38
@label Country of origin
@class string
@N_unique 216
@N 142857

[+] flags
@MIG_Data_Internationa..abase.dta

empty
(byte)

0
(0)

Flags

All properties
key	content
N	0
N_unique	0
class	empty
example0	.
label	Flags
mean	.
type	byte

Data Manipulations with flags
file	#	command

Script Output


flags:  Flags                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|                            Negative           -         -          -
|                            Zero               -         -          -
|                            Positive           -         -          -
|                                           -----     -----      -----
|                            Total              -         -          -
|                            Missing        142857
+----------------------                     -----
.             -9.0e+307                     142857
   (0 unique value)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       flags |         0
@mean         .
@sd 
@min 
@max 
@example0 .
@type byte
@label Flags
@class empty
@N_unique 0
@N 0

[+] gender
@MIG_Data_Internationa..abase.dta

constant
(str5)

142857
(1)

"Total"

Gender

All properties
key	content
N	142857
N_unique	1
class	constant
example0	Total
freq	142857
label	Gender
type	str5
values	"Total"

Data Manipulations with gender
file	#	command

Script Output

@freq 142857
@values "Total"
@example0 Total
@type str5
@label Gender
@class constant
@N_unique 1
@N 142857

[+] value
@MIG_Data_Internationa..abase.dta

other
(float)

142857
(.)

(x̄=207.019, 4776.214) [0.000,7.44e+05]

Value

All properties
key	content
N	142857
N_unique	.
class	other
example0	.011
histh	.00006843, 6.864e-08, 3.984e-08, 8.160e-09, 5.280e-09, 3.360e-09, 2.400e-09, 2.400e-09, 2.400e-09, 1.920e-09, 2.880e-09, 4.800e-10, 2.400e-09, 2.400e-09, 4.800e-10, 4.800e-10, 9.600e-10, 4.800e-10, 4.800e-10
histw	7291.3237, 21873.971, 36456.617, 51039.266, 65621.914, 80204.563, 94787.203, 109369.85, 123952.5, 138535.14, 153117.8, 167700.44, 182283.09, 196865.73, 255196.33, 532266.63, 605179.88, 692675.75, 736423.69
label	Value
max	7.44e+05
mean	207.019
min	0.000
sd	4776.214
type	float

Data Manipulations with value
file	#	command

Script Output


value:  Value                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative           -         -          -
|  #                         Zero           31085     31085          -
|  #                         Positive       111772     36943      74829
|  #                                        -----     -----      -----
|  #                         Total          142857     68028      74829
|  #   .   .   .   .         Missing            -
+----------------------                     -----
0                743715                     142857
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       value |    142857     207.019    4776.214          0     743715
@mean   207.019
@sd  4776.214
@min     0.000
@max  7.44e+05
@example0 .011
@histh .00006843, 6.864e-08, 3.984e-08, 8.160e-09, 5.280e-09, 3.360e-09, 2.400e-09, 2.400e-09, 2.400e-09, 1.920e-09, 2.880e-09, 4.800e-10, 2.400e-09, 2.400e-09, 4.800e-10, 4.800e-10, 9.600e-10, 4.800e-10, 4.800e-10
@histw 7291.3237, 21873.971, 36456.617, 51039.266, 65621.914, 80204.563, 94787.203, 109369.85, 123952.5, 138535.14, 153117.8, 167700.44, 182283.09, 196865.73, 255196.33, 532266.63, 605179.88, 692675.75, 736423.69
@type float
@label Value
@class other
@N_unique .
@N 142857

[+] variable
@MIG_Data_Internationa..abase.dta

category
(str59)

142857
(8)

"Acquisition of nationality by co..untry of birth"

Variable

All properties
key	content
N	142857
N_unique	8
class	category
freq	23286, 28285, 28040, 18877, 7502, 17863, 4062, 14942
label	Variable
type	str59
values	"Acquisition of nationality by country of former nationality", "Inflows of asylum seekers by nationality", "Inflows of foreign population by nationality", "Outflows of foreign population by nationality", "Stock of foreign labour by nationality", "Stock of foreign population by nationality", "Stock of foreign-born labour by country of birth", "Stock of foreign-born population by country of birth"

Data Manipulations with variable
file	#	command

Script Output

@freq 23286, 28285, 28040, 18877, 7502, 17863, 4062, 14942
@values "Acquisition of nationality by country of former nationality", "Inflows of asylum seekers by nationality", "Inflows of foreign population by nationality", "Outflows of foreign population by nationality", "Stock of foreign labour by nationality", "Stock of foreign population by nationality", "Stock of foreign-born labour by country of birth", "Stock of foreign-born population by country of birth"
@type str59
@label Variable
@class category
@N_unique 8
@N 142857

[+] year
@MIG_Data_Internationa..abase.dta

category
(int)

142857
(12)

"2000", "2001", "2002", "2003", ".. "2010", "2011"

Year

All properties
key	content
N	142857
N_unique	12
class	category
freq	10806, 10835, 10879, 10864, 11062, 11465, 12918, 12943, 13266, 13061, 12650, 12108
label	Year
max	2011
mean	2005.728
min	2000
names	"2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011"
sd	3.414
type	int
values	2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011

Data Manipulations with year
file	#	command

Script Output


year:  Year                                     Number of Observations
-----------                                 ------------------------------
                                            Total   Integers   Nonintegers
|                  #         Negative           -         -          -
|  #               #         Zero               -         -          -
|  #           #   #         Positive       142857     142857          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total          142857     142857          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
2000               2011                     142857
  (12 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |    142857    2005.728     3.41447       2000       2011
@mean  2005.728
@sd     3.414
@min      2000
@max      2011
@values 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011
@names "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011"
@freq 10806, 10835, 10879, 10864, 11062, 11465, 12918, 12943, 13266, 13061, 12650, 12108
@type int
@label Year
@class category
@N_unique 12
@N 142857

Content



>  * A do file to run the standard stats for a whole data set. 
>  *
>  * Note that you must delete the files in the derived directory
>  * for changes to be reflected in the output.
>  *
>  * @version 0.1
> */

Contains data from /Users/mas/Dropbox/National_Pride_Large_Data/Data/EVC_data/OECD data/Migration/MIG_Data_International_Migration_Database.dta
  obs:       255,341                          
 vars:             7                          23 Sep 2015 19:13
 size:    31,662,284                          
Sorted by:  
@N 255341
@variables 7
  255341:7(64565):140901362:4211535421
@datasignature 255341:7(64565):140901362:4211535421
panel variable not set; use xtset varname ...
. 
@_subsample 142857

- - Tokens
    Data Data International Database Database dta dta International International Migration MIG MIG Data Migration Migration Database

		Data/import.do:158
	→	Data/EVC_da..Migration_Database.dta	↘

File MIG_Data_International_Migration_Database.dta

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens